System Schema Extension Modification Registry Schema Extension Modification Registry view Actions Create New Custom Entity Custom Entity form Current Fields tab Modification Field formAdministration System Schema Extension Modification Registry Schema Extension Modification Registry view Actions Create New Custom Entity Custom Entity form Current Fields tab Modification Field form
You use the Modification Field form to add or edit dynamic entity fields.
After a field has been applied to the database, you can no longer change the field type, column name, and column length.
To add or edit a field to a dynamic custom entity:
Select the Enabled check box to add the modification to the schema update.
In the fields, provide the following information:
Field Id: Enter the ID to be used to uniquely identify this field in the entire application.
This field is prepopulated with a set prefix to enforce naming conventions (on page 1). If you remove this prefix, you cannot save your changes.
Current Database Column Name: Enter the name of the database column.
The column name is limited to database specifications. Navis also recommends not to use the keyword ‘FROM’ as a database column name when extending schemas in N4.
Do not to use the keyword ‘FROM’ as a database column name when extending schemas in N4. This keyword is subject to limitations related to the logic used to separate tables in SQL query reports.
Field Name: Enter the name of the field.
Field Desc: Enter the description of the field.
Field Type: Select the field type. For more information on the field types supported, see Supported data types (on page 1).
The field type you select affects the Field Class Name and Current Column Length fields.
Field Class Name: If the field type is Built-in enumeration or Many-to-one, select the field class from this lookup field. For all other field types, this field is unavailable because N4 automatically matches the field class name.
Current Column Length: If the field type is String, enter the current length of the database column. For all other field types, this field is unavailable.
You cannot modify the column length of a field if the snapshot has already been applied to the database. If you need to modify this field, you must first remove it from the database and then re-apply the snapshot with your modifications.
Click Save.